/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package Interface;

import Controller.CTRLActivity;
import Controller.CTRLApartment;
import Controller.CTRLCustomer;
import Controller.CTRLEmployee;
import Controller.CTRLInstructor;
import Controller.CTRLInstructorBooking;
import Controller.CTRLSportFacility;
import Controller.CTRLWaitingList;
import Database.getMax;

/**
 *
 * @author Min0
 */
public class FillDatabase
{

    public static void main(String args[])
    {
              //fillActivities();
    }

    private static void instructorBooking()
    {
        CTRLInstructorBooking CIB = new CTRLInstructorBooking();
        CIB.insertIB("1", "1", "1", "2011-06-25", "15:00", "2");
        CIB.insertIB("2", "2", "2", "2011-06-28", "10:00", "1");
        CIB.insertIB("3", "1", "3", "2011-06-21", "11:00", "1");
        CIB.insertIB("4", "3", "4", "2011-06-29", "20:00", "1");
    }
    
    private static void insertApartments()
    {
        CTRLApartment Apartment = new CTRLApartment();
        Apartment.insertApartment(1, "Single Room", "true", 60);
        Apartment.insertApartment(2, "Single Room", "false", 60);
        Apartment.insertApartment(3, "Family Room", "true", 100);
        Apartment.insertApartment(4, "Family Room", "false", 100);
        Apartment.insertApartment(5, "Family Room", "true", 100);
    }

    private static void insertCustomers()
    {
        CTRLCustomer Customer = new CTRLCustomer();
        Customer.InsertCustomer("1", "John Smith", "Gebrovej 33", "Danmark", "+45959595", "John@gmail.com", 0, 0, 0, 4);
        Customer.InsertCustomer("2", "Simona Anders", "Vester 765", "Danmark", "+45125458", "Simona@gmail.com", 0, 0, 0, 4);
        Customer.InsertCustomer("3", "Tom Cruise", "LA vej 5-4", "United States", "+85659857", "Tom@gmail.com", 0, 0, 0, 4);
        Customer.InsertCustomer("4", "T-Bag", "Gebrovej 33", "Danmark", "+45959595", "TBag@gmail.com", 0, 0, 0, 4);
        Customer.InsertCustomer("5", "Linkin Park", "Main Vej 1", "Germany", "+23656598", "LP@gmail.com", 0, 0, 0, 4);
    }

    private static void insertEmployees()
    {
        CTRLEmployee Employee = new CTRLEmployee();
        Employee.InsertEmployee("1", "Louise", "Room 1", "Austria", "+78598545", "Louise@gmail.com", "Cleaner", "Deparment 1");
        Employee.InsertEmployee("2", "Sim", "Room 2", "Estonia", "+125458755", "Sim@gmail.com", "Manager", "Deparment 1");
        Employee.InsertEmployee("3", "Lars", "Room 3", "Bulgaria", "+23568598", "Lars@gmail.com", "Cleaner", "Deparment 2");
        Employee.InsertEmployee("4", "Thomas", "Room 4", "Brazil", "+78945698", "Thomas@gmail.com", "Administrator", "Deparment 2");
        Employee.InsertEmployee("5", "Andreas", "Room 5", "Danmark", "+32658958", "Andreas@gmail.com", "Helper", "Deparment 4");
    }

    private static void insertInstructors()
    {
        CTRLInstructor Instructor = new CTRLInstructor();
        Instructor.InsertInstructor("1", "Instructor 1", "Court 1", "Japan", "1232", "smth@gmail.com", "Tennis", 30);
        Instructor.InsertInstructor("2", "Instructor 2", "Court 2", "Japan", "1232", "smth@gmail.com", "Badminton", 30);
        Instructor.InsertInstructor("3", "Instructor 3", "Court 3", "Japan", "1232", "smth@gmail.com", "Golf", 40);
        Instructor.InsertInstructor("4", "Instructor 4", "Court 4", "Japan", "1232", "smth@gmail.com", "Swimming", 40);
    }

    private static void insertSportFacilities()
    {
        CTRLSportFacility SF = new CTRLSportFacility();
        SF.insertSportFacility(1, "outdoor tennis court 1", "false", 0);
        SF.insertSportFacility(2, "outdoor tennis court 2", "false", 0);
        SF.insertSportFacility(3, "outdoor tennis court 3", "false", 0);
        SF.insertSportFacility(4, "outdoor tennis court 4", "false", 0);
        SF.insertSportFacility(5, "outdoor tennis court 5", "false", 0);
        SF.insertSportFacility(6, "outdoor tennis court 6", "false", 0);

        SF.insertSportFacility(7, "badminton court 1", "false", 0);
        SF.insertSportFacility(8, "badminton court 2", "false", 0);
        SF.insertSportFacility(9, "badminton court 3", "false", 0);
        SF.insertSportFacility(10, "badminton court 4", "false", 0);

        SF.insertSportFacility(11, "volleyball court 1", "false", 0);
        SF.insertSportFacility(12, "volleyball court 2", "false", 0);

        SF.insertSportFacility(13, "team handball court 1", "false", 0);
        SF.insertSportFacility(14, "team handball court 2", "false", 0);

        SF.insertSportFacility(15, "fitness centre", "false", 20);
    }
    
    private static void fillActivities()
    {
        CTRLActivity CA = new CTRLActivity();
        CA.insertActivity("1", "Fitness centre", 15, "2011-06-01", "10:00");
        CA.insertActivity("2", "Fitness centre", 15, "2011-06-01", "11:00");
        CA.insertActivity("3", "Fitness centre", 15, "2011-06-01", "12:00");
        CA.insertActivity("4", "Fitness centre", 15, "2011-06-01", "13:00");
        CA.insertActivity("5", "Fitness centre", 15, "2011-06-01", "14:00");
        
        CA.insertActivity("6", "outdoor tennis court 1", 1, "2011-06-01", "16:00");
    }
}
